package com.dwjm.merchant;

import com.dwjm.ConnectionDatabaseForMySQLUserJdbc;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;

public class MerchantDaoImpl implements MerchantDao {

    Connection connection = null;
    PreparedStatement pstmt = null;
    ResultSet rset = null;
    public MerchantDaoImpl() {
        connection = ConnectionDatabaseForMySQLUserJdbc.getConnection();
    }

    @Override
    public boolean login(String account, String password) {
        try {
            pstmt = connection.prepareStatement("select account from t_merchant where account=? and password=?");
            pstmt.setString(1, account);
            pstmt.setString(2, password);
            rset = pstmt.executeQuery();
            if (rset.next()) {
                return true;
            }

        }catch (Exception e) {
            e.printStackTrace();
        }
        return false;
    }

    @Override
    public int addGoods(Goods goods) {
        try {
            pstmt = connection.prepareStatement("insert into t_gods values(title,price,descr,img,state,mid)values(?,?,?,?,?,?)");
            pstmt.setString(1, goods.getTitle());
            pstmt.setBigDecimal(2, goods.getPrice());
            pstmt.setString(3, goods.getDescr());
            pstmt.setString(4, goods.getImg());
            pstmt.setInt(5,0);
            pstmt.setInt(6, goods.getMid());
            int i = pstmt.executeUpdate();
            return i == 1 ? 1 : 0;//三目运算符

        }catch (Exception exception) {
            exception.printStackTrace();
        }
        return 0;
    }
}
